var mysql = require('mysql');
var $conf = require('../conf/db');
var $util = require('../util/util');
var $sql = require('./mapper/habitMapper');

// 使用连接池，提升性能
var pool  = mysql.createPool($util.extend({}, $conf.mysql));

Date.prototype.format = function(format) {
    var date = {
        "M+": this.getMonth() + 1,
        "d+": this.getDate(),
        "h+": this.getHours(),
        "m+": this.getMinutes(),
        "s+": this.getSeconds(),
        "q+": Math.floor((this.getMonth() + 3) / 3),
        "S+": this.getMilliseconds()
    };
    if (/(y+)/i.test(format)) {
        format = format.replace(RegExp.$1, (this.getFullYear() + '').substr(4 - RegExp.$1.length));
    }
    for (var k in date) {
        if (new RegExp("(" + k + ")").test(format)) {
            format = format.replace(RegExp.$1, RegExp.$1.length == 1
                ? date[k] : ("00" + date[k]).substr(("" + date[k]).length));
        }
    }
    return format;
};
//
// var callback = function (callback) {
//
// }

module.exports = {
    insert: function (req, callback) {
        var habitName = req.habitName;
        var habitDesc = req.habitDesc;
        var createTime = new Date();
        var habitId = createTime.format('yyyyMMddhhmmss');

        callback(habitId);

        // pool.query($sql.insert, [habitId, habitName, habitDesc, createTime], function (error, results, fields) {
        //     if (error) throw error;
        //     callback(null, results);
        // });
    }
};